Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	19001
Missing cells	7531
Missing cells (%)	2.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	8.3 MiB
Average record size in memory	459.0 B

Variable types

Numeric	10
Categorical	5
DateTime	1

Alerts

`name` has a high cardinality: 18780 distinct values	High cardinality
`host_name` has a high cardinality: 6307 distinct values	High cardinality
`neighbourhood` has a high cardinality: 215 distinct values	High cardinality
`id` is highly overall correlated with `host_id`	High correlation
`host_id` is highly overall correlated with `id`	High correlation
`latitude` is highly overall correlated with `neighbourhood_group`	High correlation
`longitude` is highly overall correlated with `neighbourhood_group`	High correlation
`number_of_reviews` is highly overall correlated with `reviews_per_month`	High correlation
`reviews_per_month` is highly overall correlated with `number_of_reviews`	High correlation
`neighbourhood_group` is highly overall correlated with `latitude` and 1 other fields	High correlation
`last_review` has 3758 (19.8%) missing values	Missing
`reviews_per_month` has 3758 (19.8%) missing values	Missing
`minimum_nights` is highly skewed (γ1 = 26.36588078)	Skewed
`name` is uniformly distributed	Uniform
`id` has unique values	Unique
`number_of_reviews` has 3758 (19.8%) zeros	Zeros
`availability_365` has 6970 (36.7%) zeros	Zeros

Reproduction

Analysis started	2024-06-13 08:30:44.671537
Analysis finished	2024-06-13 08:30:51.180869
Duration	6.51 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	19001
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18830405

Minimum	2539
Maximum	36485609
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	2539
5-th percentile	1177971
Q1	9355498
median	19387536
Q3	28919516
95-th percentile	35240782
Maximum	36485609
Range	36483070
Interquartile range (IQR)	19564018

Descriptive statistics

Standard deviation	10969858
Coefficient of variation (CV)	0.5825609
Kurtosis	-1.2256633
Mean	18830405
Median Absolute Deviation (MAD)	9804926
Skewness	-0.066873715
Sum	3.5779653 × 10¹¹
Variance	1.2033778 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9138664	1	< 0.1%
17922181	1	< 0.1%
13746962	1	< 0.1%
20917712	1	< 0.1%
26734288	1	< 0.1%
10527546	1	< 0.1%
9518	1	< 0.1%
12188651	1	< 0.1%
28959608	1	< 0.1%
15158194	1	< 0.1%
Other values (18991)	18991	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2539	1	< 0.1%
3831	1	< 0.1%
5022	1	< 0.1%
5121	1	< 0.1%
5203	1	< 0.1%
5238	1	< 0.1%
5803	1	< 0.1%
6090	1	< 0.1%
6848	1	< 0.1%
7750	1	< 0.1%

Value	Count	Frequency (%)
36485609	1	< 0.1%
36485057	1	< 0.1%
36480292	1	< 0.1%
36479723	1	< 0.1%
36478343	1	< 0.1%
36472171	1	< 0.1%
36471896	1	< 0.1%
36468880	1	< 0.1%
36458668	1	< 0.1%
36456829	1	< 0.1%

name
Categorical

HIGH CARDINALITY UNIFORM

Distinct	18780
Distinct (%)	98.9%
Missing	7
Missing (%)	< 0.1%
Memory size	1.9 MiB

Hillside Hotel	7
Brooklyn Apartment	7
Home away from home	6
Private Room	6
New york Multi-unit building	5
Other values (18775)	18963

Length

Max length	179
Median length	66
Mean length	36.751395
Min length	1

Characters and Unicode

Total characters	698056
Distinct characters	504
Distinct categories	20 ?
Distinct scripts	11 ?
Distinct blocks	17 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18619 ?
Unique (%)	98.0%

Sample

1st row	Private Lg Room 15 min to Manhattan
2nd row	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC
3rd row	Voted #1 Location Quintessential 1BR W Village Apt
4th row	Spacious 1 bedroom apartment 15min from Manhattan
5th row	Big beautiful bedroom in huge Bushwick apartment

Common Values

Value	Count	Frequency (%)
Hillside Hotel	7	< 0.1%
Brooklyn Apartment	7	< 0.1%
Home away from home	6	< 0.1%
Private Room	6	< 0.1%
New york Multi-unit building	5	< 0.1%
Cozy Room	5	< 0.1%
Private room in Manhattan	5	< 0.1%
Private room in Williamsburg	4	< 0.1%
Cozy Private Room	4	< 0.1%
Williamsburg Loft	3	< 0.1%
Other values (18770)	18942	99.7%
(Missing)	7	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
in	6594	5.7%
room	4014	3.5%
	3161	2.7%
bedroom	3016	2.6%
private	2874	2.5%
apartment	2658	2.3%
cozy	2017	1.7%
apt	1765	1.5%
brooklyn	1623	1.4%
studio	1556	1.3%
Other values (6673)	86285	74.7%

Most occurring characters

Value	Count	Frequency (%)
	97219	13.9%
e	48065	6.9%
o	47895	6.9%
t	40878	5.9%
a	40431	5.8%
r	38293	5.5%
i	36980	5.3%
n	36723	5.3%
l	20035	2.9%
m	19434	2.8%
Other values (494)	272103	39.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	469006	67.2%
Uppercase Letter	102950	14.7%
Space Separator	97221	13.9%
Other Punctuation	12924	1.9%
Decimal Number	9521	1.4%
Dash Punctuation	2620	0.4%
Other Letter	976	0.1%
Math Symbol	970	0.1%
Close Punctuation	621	0.1%
Open Punctuation	568	0.1%
Other values (10)	679	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
房	36	3.7%
间	22	2.3%
中	21	2.2%
拉	19	1.9%
法	18	1.8%
盛	18	1.8%
家	16	1.6%
温	15	1.5%
的	15	1.5%
心	13	1.3%
Other values (299)	783	80.2%

Lowercase Letter

Value	Count	Frequency (%)
e	48065	10.2%
o	47895	10.2%
t	40878	8.7%
a	40431	8.6%
r	38293	8.2%
i	36980	7.9%
n	36723	7.8%
l	20035	4.3%
m	19434	4.1%
s	18729	4.0%
Other values (48)	121543	25.9%

Other Symbol

Value	Count	Frequency (%)
★	95	28.5%
❤	66	19.8%
☆	31	9.3%
⭐	19	5.7%
♥	14	4.2%
✨	13	3.9%
❥	13	3.9%
✰	8	2.4%
✿	7	2.1%
☀	6	1.8%
Other values (27)	61	18.3%

Uppercase Letter

Value	Count	Frequency (%)
B	11484	11.2%
S	10080	9.8%
C	8176	7.9%
A	7545	7.3%
R	6917	6.7%
P	5740	5.6%
E	5345	5.2%
L	5288	5.1%
M	4520	4.4%
N	4373	4.2%
Other values (23)	33482	32.5%

Other Punctuation

Value	Count	Frequency (%)
,	3504	27.1%
!	3055	23.6%
/	1958	15.2%
.	1683	13.0%
&	1234	9.5%
'	425	3.3%
*	329	2.5%
:	225	1.7%
#	212	1.6%
"	111	0.9%
Other values (9)	188	1.5%

Decimal Number

Value	Count	Frequency (%)
1	3413	35.8%
2	2526	26.5%
3	931	9.8%
5	800	8.4%
0	768	8.1%
4	459	4.8%
6	233	2.4%
8	150	1.6%
7	147	1.5%
9	94	1.0%

Math Symbol

Value	Count	Frequency (%)
+	476	49.1%
\|	359	37.0%
~	99	10.2%
=	11	1.1%
>	9	0.9%
<	7	0.7%
￫	6	0.6%
√	2	0.2%
×	1	0.1%

Close Punctuation

Value	Count	Frequency (%)
)	596	96.0%
]	17	2.7%
}	4	0.6%
】	3	0.5%
》	1	0.2%

Open Punctuation

Value	Count	Frequency (%)
(	544	95.8%
[	16	2.8%
{	4	0.7%
【	3	0.5%
《	1	0.2%

Dash Punctuation

Value	Count	Frequency (%)
-	2589	98.8%
—	16	0.6%
–	15	0.6%

Space Separator

Value	Count	Frequency (%)
	97219	> 99.9%
	2	< 0.1%

Final Punctuation

Value	Count	Frequency (%)
’	89	86.4%
”	14	13.6%

Nonspacing Mark

Value	Count	Frequency (%)
️	66	88.0%
︎	9	12.0%

Initial Punctuation

Value	Count	Frequency (%)
“	15	78.9%
‘	4	21.1%

Modifier Letter

Value	Count	Frequency (%)
ﾞ	7	70.0%
ｰ	3	30.0%

Modifier Symbol

Value	Count	Frequency (%)
^	6	85.7%
`	1	14.3%

Control

Value	Count	Frequency (%)
	72	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	34	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	20	100.0%

Other Number

Value	Count	Frequency (%)
²	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	571873	81.9%
Common	125049	17.9%
Han	878	0.1%
Inherited	75	< 0.1%
Cyrillic	71	< 0.1%
Katakana	45	< 0.1%
Hebrew	31	< 0.1%
Georgian	12	< 0.1%
Hiragana	12	< 0.1%
Hangul	8	< 0.1%

Most frequent character per script

Han

Value	Count	Frequency (%)
房	36	4.1%
间	22	2.5%
中	21	2.4%
拉	19	2.2%
法	18	2.1%
盛	18	2.1%
家	16	1.8%
温	15	1.7%
的	15	1.7%
心	13	1.5%
Other values (244)	685	78.0%

Common

Value	Count	Frequency (%)
	97219	77.7%
,	3504	2.8%
1	3413	2.7%
!	3055	2.4%
-	2589	2.1%
2	2526	2.0%
/	1958	1.6%
.	1683	1.3%
&	1234	1.0%
3	931	0.7%
Other values (92)	6937	5.5%

Latin

Value	Count	Frequency (%)
e	48065	8.4%
o	47895	8.4%
t	40878	7.1%
a	40431	7.1%
r	38293	6.7%
i	36980	6.5%
n	36723	6.4%
l	20035	3.5%
m	19434	3.4%
s	18729	3.3%
Other values (61)	224410	39.2%

Katakana

Value	Count	Frequency (%)
ﾝ	7	15.6%
ﾄ	5	11.1%
ﾀ	3	6.7%
ｳ	3	6.7%
ｸ	3	6.7%
ｯ	3	6.7%
ｽ	2	4.4%
ﾐ	2	4.4%
ｻ	1	2.2%
ｴ	1	2.2%
Other values (15)	15	33.3%

Cyrillic

Value	Count	Frequency (%)
а	10	14.1%
т	7	9.9%
н	7	9.9%
с	6	8.5%
о	6	8.5%
к	5	7.0%
е	4	5.6%
м	4	5.6%
р	3	4.2%
я	3	4.2%
Other values (9)	16	22.5%

Hebrew

Value	Count	Frequency (%)
ו	5	16.1%
י	5	16.1%
ב	4	12.9%
ר	4	12.9%
ה	2	6.5%
ת	2	6.5%
ע	2	6.5%
א	1	3.2%
מ	1	3.2%
ס	1	3.2%
Other values (4)	4	12.9%

Hangul

Value	Count	Frequency (%)
뜻	1	12.5%
따	1	12.5%
한	1	12.5%
건	1	12.5%
작	1	12.5%
은	1	12.5%
물	1	12.5%
웃	1	12.5%

Hiragana

Value	Count	Frequency (%)
の	5	41.7%
お	2	16.7%
な	1	8.3%
で	1	8.3%
す	1	8.3%
に	1	8.3%
い	1	8.3%

Inherited

Value	Count	Frequency (%)
️	66	88.0%
︎	9	12.0%

Georgian

Value	Count	Frequency (%)
ღ	12	100.0%

Devanagari

Value	Count	Frequency (%)
ॐ	2	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	696288	99.7%
CJK	878	0.1%
Punctuation	187	< 0.1%
None	179	< 0.1%
Misc Symbols	176	< 0.1%
Dingbats	130	< 0.1%
VS	75	< 0.1%
Cyrillic	71	< 0.1%
Hebrew	31	< 0.1%
Georgian	12	< 0.1%
Other values (7)	29	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	97219	14.0%
e	48065	6.9%
o	47895	6.9%
t	40878	5.9%
a	40431	5.8%
r	38293	5.5%
i	36980	5.3%
n	36723	5.3%
l	20035	2.9%
m	19434	2.8%
Other values (86)	270335	38.8%

Misc Symbols

Value	Count	Frequency (%)
★	95	54.0%
☆	31	17.6%
♥	14	8.0%
☀	6	3.4%
♀	5	2.8%
⚡	4	2.3%
⚓	3	1.7%
☺	3	1.7%
♕	2	1.1%
♛	2	1.1%
Other values (6)	11	6.2%

Punctuation

Value	Count	Frequency (%)
’	89	47.6%
•	34	18.2%
—	16	8.6%
“	15	8.0%
–	15	8.0%
”	14	7.5%
‘	4	2.1%

VS

Value	Count	Frequency (%)
️	66	88.0%
︎	9	12.0%

Dingbats

Value	Count	Frequency (%)
❤	66	50.8%
✨	13	10.0%
❥	13	10.0%
✰	8	6.2%
✿	7	5.4%
✪	5	3.8%
✦	4	3.1%
✴	4	3.1%
✮	3	2.3%
✩	2	1.5%
Other values (3)	5	3.8%

CJK

Value	Count	Frequency (%)
房	36	4.1%
间	22	2.5%
中	21	2.4%
拉	19	2.2%
法	18	2.1%
盛	18	2.1%
家	16	1.8%
温	15	1.7%
的	15	1.7%
心	13	1.5%
Other values (244)	685	78.0%

None

Value	Count	Frequency (%)
⭐	19	10.6%
à	15	8.4%
ó	9	5.0%
·	7	3.9%
é	7	3.9%
ﾝ	7	3.9%
ﾞ	7	3.9%
｡	7	3.9%
²	6	3.4%
￫	6	3.4%
Other values (51)	89	49.7%

Georgian

Value	Count	Frequency (%)
ღ	12	100.0%

Cyrillic

Value	Count	Frequency (%)
а	10	14.1%
т	7	9.9%
н	7	9.9%
с	6	8.5%
о	6	8.5%
к	5	7.0%
е	4	5.6%
м	4	5.6%
р	3	4.2%
я	3	4.2%
Other values (9)	16	22.5%

Hebrew

Value	Count	Frequency (%)
ו	5	16.1%
י	5	16.1%
ב	4	12.9%
ר	4	12.9%
ה	2	6.5%
ת	2	6.5%
ע	2	6.5%
א	1	3.2%
מ	1	3.2%
ס	1	3.2%
Other values (4)	4	12.9%

Hiragana

Value	Count	Frequency (%)
の	5	41.7%
お	2	16.7%
な	1	8.3%
で	1	8.3%
す	1	8.3%
に	1	8.3%
い	1	8.3%

Geometric Shapes

Value	Count	Frequency (%)
▲	2	100.0%

Math Operators

Value	Count	Frequency (%)
√	2	100.0%

Devanagari

Value	Count	Frequency (%)
ॐ	2	100.0%

Hangul

Value	Count	Frequency (%)
뜻	1	12.5%
따	1	12.5%
한	1	12.5%
건	1	12.5%
작	1	12.5%
은	1	12.5%
물	1	12.5%
웃	1	12.5%

Letterlike Symbols

Value	Count	Frequency (%)
™	1	100.0%

Misc Technical

Value	Count	Frequency (%)
⏩	1	50.0%
⏪	1	50.0%

host_id
Real number (ℝ)

Distinct	16241
Distinct (%)	85.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	66394589

Minimum	2571
Maximum	2.7427328 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	2571
5-th percentile	764688
Q1	7728754
median	30487854
Q3	1.0483536 × 10⁸
95-th percentile	2.3951918 × 10⁸
Maximum	2.7427328 × 10⁸
Range	2.7427071 × 10⁸
Interquartile range (IQR)	97106602

Descriptive statistics

Standard deviation	77826632
Coefficient of variation (CV)	1.1721834
Kurtosis	0.28986658
Mean	66394589
Median Absolute Deviation (MAD)	27185317
Skewness	1.2459588
Sum	1.2615636 × 10¹²
Variance	6.0569847 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
219517861	117	0.6%
107434423	71	0.4%
30283594	44	0.2%
137358866	36	0.2%
12243051	36	0.2%
61391963	34	0.2%
16098958	33	0.2%
22541573	32	0.2%
26377263	24	0.1%
2856748	22	0.1%
Other values (16231)	18552	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2571	1	< 0.1%
2787	3	< 0.1%
3151	1	< 0.1%
3415	1	< 0.1%
3563	1	< 0.1%
3647	2	< 0.1%
4396	1	< 0.1%
4869	1	< 0.1%
5089	1	< 0.1%
6041	1	< 0.1%

Value	Count	Frequency (%)
274273284	1	< 0.1%
274195458	1	< 0.1%
274103383	1	< 0.1%
273870123	1	< 0.1%
273841667	1	< 0.1%
273741577	1	< 0.1%
273656890	1	< 0.1%
273632292	1	< 0.1%
273619304	1	< 0.1%
273613106	1	< 0.1%

host_name
Categorical

Distinct	6307
Distinct (%)	33.2%
Missing	8
Missing (%)	< 0.1%
Memory size	1.3 MiB

Michael	159
David	157
John	130
Sonder (NYC)	117
Alex	98
Other values (6302)	18332

Length

Max length	35
Median length	31
Mean length	6.1009319
Min length	1

Characters and Unicode

Total characters	115875
Distinct characters	138
Distinct categories	11 ?
Distinct scripts	6 ?
Distinct blocks	7 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4077 ?
Unique (%)	21.5%

Sample

1st row	Iris
2nd row	Johlex
3rd row	John
4th row	Regan
5th row	Megan

Common Values

Value	Count	Frequency (%)
Michael	159	0.8%
David	157	0.8%
John	130	0.7%
Sonder (NYC)	117	0.6%
Alex	98	0.5%
Daniel	92	0.5%
Sarah	87	0.5%
Maria	86	0.5%
Chris	81	0.4%
Anna	77	0.4%
Other values (6297)	17909	94.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	401	1.9%
and	234	1.1%
michael	175	0.8%
david	169	0.8%
sonder	153	0.7%
john	145	0.7%
nyc	122	0.6%
alex	121	0.6%
laura	117	0.6%
maria	105	0.5%
Other values (5877)	19369	91.7%

Most occurring characters

Value	Count	Frequency (%)
a	14760	12.7%
e	11187	9.7%
i	9409	8.1%
n	9394	8.1%
r	6989	6.0%
l	5914	5.1%
o	4954	4.3%
t	3638	3.1%
s	3533	3.0%
h	3518	3.0%
Other values (128)	42579	36.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	91499	79.0%
Uppercase Letter	21211	18.3%
Space Separator	2158	1.9%
Other Punctuation	579	0.5%
Open Punctuation	134	0.1%
Close Punctuation	134	0.1%
Dash Punctuation	76	0.1%
Other Letter	39	< 0.1%
Decimal Number	30	< 0.1%
Math Symbol	14	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	14760	16.1%
e	11187	12.2%
i	9409	10.3%
n	9394	10.3%
r	6989	7.6%
l	5914	6.5%
o	4954	5.4%
t	3638	4.0%
s	3533	3.9%
h	3518	3.8%
Other values (46)	18203	19.9%

Uppercase Letter

Value	Count	Frequency (%)
A	2475	11.7%
J	2094	9.9%
M	2051	9.7%
S	1821	8.6%
C	1432	6.8%
L	1124	5.3%
D	1079	5.1%
K	1024	4.8%
R	989	4.7%
E	937	4.4%
Other values (22)	6185	29.2%

Other Letter

Value	Count	Frequency (%)
明	3	7.7%
美	3	7.7%
德	3	7.7%
青	3	7.7%
辣	2	5.1%
柏	2	5.1%
润	2	5.1%
铀	2	5.1%
宇	1	2.6%
泽	1	2.6%
Other values (17)	17	43.6%

Other Punctuation

Value	Count	Frequency (%)
&	415	71.7%
.	122	21.1%
/	14	2.4%
,	13	2.2%
'	7	1.2%
!	4	0.7%
@	3	0.5%
:	1	0.2%

Decimal Number

Value	Count	Frequency (%)
5	7	23.3%
7	5	16.7%
0	5	16.7%
1	4	13.3%
2	3	10.0%
4	3	10.0%
6	2	6.7%
3	1	3.3%

Space Separator

Value	Count	Frequency (%)
	2154	99.8%
	4	0.2%

Open Punctuation

Value	Count	Frequency (%)
(	134	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	134	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	76	100.0%

Math Symbol

Value	Count	Frequency (%)
+	14	100.0%

Currency Symbol

Value	Count	Frequency (%)
£	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	112687	97.2%
Common	3126	2.7%
Han	34	< 0.1%
Cyrillic	23	< 0.1%
Hiragana	3	< 0.1%
Hangul	2	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	14760	13.1%
e	11187	9.9%
i	9409	8.3%
n	9394	8.3%
r	6989	6.2%
l	5914	5.2%
o	4954	4.4%
t	3638	3.2%
s	3533	3.1%
h	3518	3.1%
Other values (63)	39391	35.0%

Common

Value	Count	Frequency (%)
	2154	68.9%
&	415	13.3%
(	134	4.3%
)	134	4.3%
.	122	3.9%
-	76	2.4%
+	14	0.4%
/	14	0.4%
,	13	0.4%
5	7	0.2%
Other values (13)	43	1.4%

Han

Value	Count	Frequency (%)
明	3	8.8%
美	3	8.8%
德	3	8.8%
青	3	8.8%
辣	2	5.9%
柏	2	5.9%
润	2	5.9%
铀	2	5.9%
宇	1	2.9%
泽	1	2.9%
Other values (12)	12	35.3%

Cyrillic

Value	Count	Frequency (%)
А	3	13.0%
е	3	13.0%
л	2	8.7%
и	2	8.7%
й	2	8.7%
н	2	8.7%
р	1	4.3%
Ю	1	4.3%
т	1	4.3%
а	1	4.3%
Other values (5)	5	21.7%

Hiragana

Value	Count	Frequency (%)
あ	1	33.3%
り	1	33.3%
ゆ	1	33.3%

Hangul

Value	Count	Frequency (%)
소	1	50.0%
정	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	115704	99.9%
None	105	0.1%
CJK	34	< 0.1%
Cyrillic	23	< 0.1%
Punctuation	4	< 0.1%
Hiragana	3	< 0.1%
Hangul	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	14760	12.8%
e	11187	9.7%
i	9409	8.1%
n	9394	8.1%
r	6989	6.0%
l	5914	5.1%
o	4954	4.3%
t	3638	3.1%
s	3533	3.1%
h	3518	3.0%
Other values (63)	42408	36.7%

None

Value	Count	Frequency (%)
é	42	40.0%
á	10	9.5%
í	9	8.6%
ë	8	7.6%
è	6	5.7%
ô	6	5.7%
ú	5	4.8%
ç	2	1.9%
ï	2	1.9%
ı	2	1.9%
Other values (12)	13	12.4%

Punctuation

Value	Count	Frequency (%)
	4	100.0%

CJK

Value	Count	Frequency (%)
明	3	8.8%
美	3	8.8%
德	3	8.8%
青	3	8.8%
辣	2	5.9%
柏	2	5.9%
润	2	5.9%
铀	2	5.9%
宇	1	2.9%
泽	1	2.9%
Other values (12)	12	35.3%

Cyrillic

Value	Count	Frequency (%)
А	3	13.0%
е	3	13.0%
л	2	8.7%
и	2	8.7%
й	2	8.7%
н	2	8.7%
р	1	4.3%
Ю	1	4.3%
т	1	4.3%
а	1	4.3%
Other values (5)	5	21.7%

Hiragana

Value	Count	Frequency (%)
あ	1	33.3%
り	1	33.3%
ゆ	1	33.3%

Hangul

Value	Count	Frequency (%)
소	1	50.0%
정	1	50.0%

neighbourhood_group
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Brooklyn	8046
Manhattan	8031
Queens	2331
Bronx	434
Staten Island	159

Length

Max length	13
Median length	9
Mean length	8.1506237
Min length	5

Characters and Unicode

Total characters	154870
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Queens
2nd row	Manhattan
3rd row	Manhattan
4th row	Queens
5th row	Brooklyn

Common Values

Value	Count	Frequency (%)
Brooklyn	8046	42.3%
Manhattan	8031	42.3%
Queens	2331	12.3%
Bronx	434	2.3%
Staten Island	159	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
brooklyn	8046	42.0%
manhattan	8031	41.9%
queens	2331	12.2%
bronx	434	2.3%
staten	159	0.8%
island	159	0.8%

Most occurring characters

Value	Count	Frequency (%)
n	27191	17.6%
a	24411	15.8%
o	16526	10.7%
t	16380	10.6%
r	8480	5.5%
B	8480	5.5%
l	8205	5.3%
y	8046	5.2%
k	8046	5.2%
M	8031	5.2%
Other values (10)	21074	13.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	135551	87.5%
Uppercase Letter	19160	12.4%
Space Separator	159	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	27191	20.1%
a	24411	18.0%
o	16526	12.2%
t	16380	12.1%
r	8480	6.3%
l	8205	6.1%
y	8046	5.9%
k	8046	5.9%
h	8031	5.9%
e	4821	3.6%
Other values (4)	5414	4.0%

Uppercase Letter

Value	Count	Frequency (%)
B	8480	44.3%
M	8031	41.9%
Q	2331	12.2%
S	159	0.8%
I	159	0.8%

Space Separator

Value	Count	Frequency (%)
	159	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	154711	99.9%
Common	159	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	27191	17.6%
a	24411	15.8%
o	16526	10.7%
t	16380	10.6%
r	8480	5.5%
B	8480	5.5%
l	8205	5.3%
y	8046	5.2%
k	8046	5.2%
M	8031	5.2%
Other values (9)	20915	13.5%

Common

Value	Count	Frequency (%)
	159	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	154870	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	27191	17.6%
a	24411	15.8%
o	16526	10.7%
t	16380	10.6%
r	8480	5.5%
B	8480	5.5%
l	8205	5.3%
y	8046	5.2%
k	8046	5.2%
M	8031	5.2%
Other values (10)	21074	13.6%

neighbourhood
Categorical

Distinct	215
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Williamsburg	1526
Bedford-Stuyvesant	1478
Harlem	1086
Bushwick	978
Upper West Side	734
Other values (210)	13199

Length

Max length	26
Median length	17
Mean length	11.919478
Min length	4

Characters and Unicode

Total characters	226482
Distinct characters	54
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19 ?
Unique (%)	0.1%

Sample

1st row	Sunnyside
2nd row	Hell's Kitchen
3rd row	West Village
4th row	Astoria
5th row	Bushwick

Common Values

Value	Count	Frequency (%)
Williamsburg	1526	8.0%
Bedford-Stuyvesant	1478	7.8%
Harlem	1086	5.7%
Bushwick	978	5.1%
Upper West Side	734	3.9%
East Village	705	3.7%
Hell's Kitchen	693	3.6%
Upper East Side	667	3.5%
Crown Heights	631	3.3%
Midtown	505	2.7%
Other values (205)	9998	52.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
east	2575	8.4%
side	1756	5.7%
harlem	1540	5.0%
williamsburg	1526	5.0%
bedford-stuyvesant	1478	4.8%
heights	1427	4.7%
upper	1401	4.6%
village	1186	3.9%
west	1033	3.4%
bushwick	978	3.2%
Other values (227)	15760	51.4%

Most occurring characters

Value	Count	Frequency (%)
e	20714	9.1%
i	16226	7.2%
s	15652	6.9%
t	15047	6.6%
a	14816	6.5%
l	13284	5.9%
r	13260	5.9%
	11659	5.1%
n	10202	4.5%
o	9383	4.1%
Other values (44)	86239	38.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	179812	79.4%
Uppercase Letter	32558	14.4%
Space Separator	11659	5.1%
Dash Punctuation	1707	0.8%
Other Punctuation	746	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	20714	11.5%
i	16226	9.0%
s	15652	8.7%
t	15047	8.4%
a	14816	8.2%
l	13284	7.4%
r	13260	7.4%
n	10202	5.7%
o	9383	5.2%
d	7624	4.2%
Other values (15)	43604	24.2%

Uppercase Letter

Value	Count	Frequency (%)
H	4667	14.3%
S	4437	13.6%
B	3298	10.1%
W	3154	9.7%
E	2772	8.5%
C	2107	6.5%
G	1464	4.5%
U	1429	4.4%
F	1324	4.1%
V	1208	3.7%
Other values (14)	6698	20.6%

Other Punctuation

Value	Count	Frequency (%)
'	697	93.4%
.	48	6.4%
,	1	0.1%

Space Separator

Value	Count	Frequency (%)
	11659	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1707	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	212370	93.8%
Common	14112	6.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	20714	9.8%
i	16226	7.6%
s	15652	7.4%
t	15047	7.1%
a	14816	7.0%
l	13284	6.3%
r	13260	6.2%
n	10202	4.8%
o	9383	4.4%
d	7624	3.6%
Other values (39)	76162	35.9%

Common

Value	Count	Frequency (%)
	11659	82.6%
-	1707	12.1%
'	697	4.9%
.	48	0.3%
,	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	226482	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	20714	9.1%
i	16226	7.2%
s	15652	6.9%
t	15047	6.6%
a	14816	6.5%
l	13284	5.9%
r	13260	5.9%
	11659	5.1%
n	10202	4.5%
o	9383	4.1%
Other values (44)	86239	38.1%

latitude
Real number (ℝ)

Distinct	12087
Distinct (%)	63.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.728063

Minimum	40.50873
Maximum	40.91306
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	40.50873
5-th percentile	40.64456
Q1	40.68882
median	40.72171
Q3	40.76321
95-th percentile	40.82645
Maximum	40.91306
Range	0.40433
Interquartile range (IQR)	0.07439

Descriptive statistics

Standard deviation	0.05538931
Coefficient of variation (CV)	0.001359979
Kurtosis	0.05864488
Mean	40.728063
Median Absolute Deviation (MAD)	0.03659
Skewness	0.2542518
Sum	773873.93
Variance	0.0030679757
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.71813	8	< 0.1%
40.72232	8	< 0.1%
40.68634	8	< 0.1%
40.69414	8	< 0.1%
40.68683	7	< 0.1%
40.72607	7	< 0.1%
40.68084	7	< 0.1%
40.72434	6	< 0.1%
40.76389	6	< 0.1%
40.70741	6	< 0.1%
Other values (12077)	18930	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
40.50873	1	< 0.1%
40.52293	1	< 0.1%
40.53871	1	< 0.1%
40.53939	1	< 0.1%
40.54106	1	< 0.1%
40.54312	1	< 0.1%
40.5455	1	< 0.1%
40.54857	1	< 0.1%
40.54889	1	< 0.1%
40.54901	1	< 0.1%

Value	Count	Frequency (%)
40.91306	1	< 0.1%
40.90527	1	< 0.1%
40.90391	1	< 0.1%
40.90356	1	< 0.1%
40.90329	1	< 0.1%
40.90281	1	< 0.1%
40.9026	1	< 0.1%
40.89981	1	< 0.1%
40.89811	1	< 0.1%
40.89756	1	< 0.1%

longitude
Real number (ℝ)

Distinct	9944
Distinct (%)	52.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-73.950827

Minimum	-74.23914
Maximum	-73.71795
Zeros	0
Zeros (%)	0.0%
Negative	19001
Negative (%)	100.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	-74.23914
5-th percentile	-74.00369
Q1	-73.98205
median	-73.95463
Q3	-73.93449
95-th percentile	-73.86186
Maximum	-73.71795
Range	0.52119
Interquartile range (IQR)	0.04756

Descriptive statistics

Standard deviation	0.046824987
Coefficient of variation (CV)	-0.00063319085
Kurtosis	4.8242797
Mean	-73.950827
Median Absolute Deviation (MAD)	0.02489
Skewness	1.2340208
Sum	-1405139.7
Variance	0.0021925794
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.94829	9	< 0.1%
-73.95725	9	< 0.1%
-73.95121	9	< 0.1%
-73.95742	9	< 0.1%
-73.95427	9	< 0.1%
-73.98589	9	< 0.1%
-73.95675	8	< 0.1%
-73.9567	8	< 0.1%
-73.95149	8	< 0.1%
-73.98043	8	< 0.1%
Other values (9934)	18915	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-74.23914	1	< 0.1%
-74.21238	1	< 0.1%
-74.19626	1	< 0.1%
-74.18259	1	< 0.1%
-74.17628	1	< 0.1%
-74.17388	1	< 0.1%
-74.17117	1	< 0.1%
-74.17065	1	< 0.1%
-74.16966	1	< 0.1%
-74.16634	1	< 0.1%

Value	Count	Frequency (%)
-73.71795	1	< 0.1%
-73.71829	1	< 0.1%
-73.72582	1	< 0.1%
-73.72716	1	< 0.1%
-73.72731	1	< 0.1%
-73.7274	1	< 0.1%
-73.72778	1	< 0.1%
-73.72817	1	< 0.1%
-73.72901	1	< 0.1%
-73.72928	1	< 0.1%

room_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Entire home/apt	9522
Private room	9041
Shared room	438

Length

Max length	15
Median length	15
Mean length	13.480343
Min length	11

Characters and Unicode

Total characters	256140
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Private room

Common Values

Value	Count	Frequency (%)
Entire home/apt	9522	50.1%
Private room	9041	47.6%
Shared room	438	2.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	9522	25.1%
home/apt	9522	25.1%
room	9479	24.9%
private	9041	23.8%
shared	438	1.2%

Most occurring characters

Value	Count	Frequency (%)
e	28523	11.1%
o	28480	11.1%
r	28480	11.1%
t	28085	11.0%
a	19001	7.4%
	19001	7.4%
m	19001	7.4%
i	18563	7.2%
h	9960	3.9%
p	9522	3.7%
Other values (7)	47524	18.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	208616	81.4%
Space Separator	19001	7.4%
Uppercase Letter	19001	7.4%
Other Punctuation	9522	3.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	28523	13.7%
o	28480	13.7%
r	28480	13.7%
t	28085	13.5%
a	19001	9.1%
m	19001	9.1%
i	18563	8.9%
h	9960	4.8%
p	9522	4.6%
n	9522	4.6%
Other values (2)	9479	4.5%

Uppercase Letter

Value	Count	Frequency (%)
E	9522	50.1%
P	9041	47.6%
S	438	2.3%

Space Separator

Value	Count	Frequency (%)
	19001	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	9522	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	227617	88.9%
Common	28523	11.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	28523	12.5%
o	28480	12.5%
r	28480	12.5%
t	28085	12.3%
a	19001	8.3%
m	19001	8.3%
i	18563	8.2%
h	9960	4.4%
p	9522	4.2%
E	9522	4.2%
Other values (5)	28480	12.5%

Common

Value	Count	Frequency (%)
	19001	66.6%
/	9522	33.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	256140	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	28523	11.1%
o	28480	11.1%
r	28480	11.1%
t	28085	11.0%
a	19001	7.4%
	19001	7.4%
m	19001	7.4%
i	18563	7.2%
h	9960	3.9%
p	9522	3.7%
Other values (7)	47524	18.6%

price
Real number (ℝ)

Distinct	321
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.34046

Minimum	10
Maximum	350
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	10
5-th percentile	40
Q1	66
median	100
Q3	160
95-th percentile	270
Maximum	350
Range	340
Interquartile range (IQR)	94

Descriptive statistics

Standard deviation	71.530346
Coefficient of variation (CV)	0.58468268
Kurtosis	0.50280069
Mean	122.34046
Median Absolute Deviation (MAD)	45
Skewness	1.0270244
Sum	2324591
Variance	5116.5903
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	856	4.5%
150	821	4.3%
50	636	3.3%
200	590	3.1%
75	570	3.0%
60	555	2.9%
80	531	2.8%
70	482	2.5%
120	471	2.5%
65	471	2.5%
Other values (311)	13018	68.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	6	< 0.1%
11	2	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
15	1	< 0.1%
16	3	< 0.1%
18	1	< 0.1%
19	3	< 0.1%
20	13	0.1%
21	3	< 0.1%

Value	Count	Frequency (%)
350	147	0.8%
349	14	0.1%
348	1	< 0.1%
347	2	< 0.1%
346	1	< 0.1%
345	11	0.1%
344	1	< 0.1%
343	2	< 0.1%
342	1	< 0.1%
341	2	< 0.1%

minimum_nights
Real number (ℝ)

Distinct	75
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.9068996

Minimum	1
Maximum	1250
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	30
Maximum	1250
Range	1249
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	21.456544
Coefficient of variation (CV)	3.1065377
Kurtosis	1156.4552
Mean	6.9068996
Median Absolute Deviation (MAD)	1
Skewness	26.365881
Sum	131238
Variance	460.38328
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	5003	26.3%
2	4619	24.3%
3	3086	16.2%
30	1442	7.6%
4	1253	6.6%
5	1140	6.0%
7	822	4.3%
6	285	1.5%
14	210	1.1%
10	178	0.9%
Other values (65)	963	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5003	26.3%
2	4619	24.3%
3	3086	16.2%
4	1253	6.6%
5	1140	6.0%
6	285	1.5%
7	822	4.3%
8	52	0.3%
9	34	0.2%
10	178	0.9%

Value	Count	Frequency (%)
1250	1	< 0.1%
999	2	< 0.1%
480	1	< 0.1%
400	1	< 0.1%
370	1	< 0.1%
365	11	0.1%
364	1	< 0.1%
300	1	< 0.1%
299	1	< 0.1%
240	2	< 0.1%

number_of_reviews
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	321
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.797747

Minimum	0
Maximum	607
Zeros	3758
Zeros (%)	19.8%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	24
95-th percentile	116
Maximum	607
Range	607
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	45.493455
Coefficient of variation (CV)	1.9116706
Kurtosis	19.565921
Mean	23.797747
Median Absolute Deviation (MAD)	6
Skewness	3.7060188
Sum	452181
Variance	2069.6544
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3758	19.8%
1	2022	10.6%
2	1342	7.1%
3	975	5.1%
4	796	4.2%
5	589	3.1%
6	544	2.9%
7	495	2.6%
8	449	2.4%
9	383	2.0%
Other values (311)	7648	40.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3758	19.8%
1	2022	10.6%
2	1342	7.1%
3	975	5.1%
4	796	4.2%
5	589	3.1%
6	544	2.9%
7	495	2.6%
8	449	2.4%
9	383	2.0%

Value	Count	Frequency (%)
607	1	< 0.1%
594	1	< 0.1%
510	1	< 0.1%
488	1	< 0.1%
474	1	< 0.1%
467	1	< 0.1%
466	1	< 0.1%
459	1	< 0.1%
448	1	< 0.1%
441	1	< 0.1%

last_review
Date

Distinct	1494
Distinct (%)	9.8%
Missing	3758
Missing (%)	19.8%
Memory size	296.9 KiB

Minimum	2011-05-12 00:00:00
Maximum	2019-07-08 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

reviews_per_month
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	789
Distinct (%)	5.2%
Missing	3758
Missing (%)	19.8%
Infinite	0
Infinite (%)	0.0%
Mean	1.3809276

Minimum	0.01
Maximum	27.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.04
Q1	0.19
median	0.72
Q3	2.01
95-th percentile	4.69
Maximum	27.95
Range	27.94
Interquartile range (IQR)	1.82

Descriptive statistics

Standard deviation	1.6899884
Coefficient of variation (CV)	1.2238066
Kurtosis	11.9516
Mean	1.3809276
Median Absolute Deviation (MAD)	0.62
Skewness	2.4353306
Sum	21049.48
Variance	2.8560608
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02	362	1.9%
1	352	1.9%
0.05	333	1.8%
0.03	323	1.7%
0.04	268	1.4%
0.08	256	1.3%
0.16	244	1.3%
0.09	235	1.2%
0.06	226	1.2%
0.11	217	1.1%
Other values (779)	12427	65.4%
(Missing)	3758	19.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	17	0.1%
0.02	362	1.9%
0.03	323	1.7%
0.04	268	1.4%
0.05	333	1.8%
0.06	226	1.2%
0.07	168	0.9%
0.08	256	1.3%
0.09	235	1.2%
0.1	191	1.0%

Value	Count	Frequency (%)
27.95	1	< 0.1%
20.94	1	< 0.1%
19.75	1	< 0.1%
17.82	1	< 0.1%
16.22	1	< 0.1%
13.45	1	< 0.1%
13.42	1	< 0.1%
13.24	1	< 0.1%
13.15	1	< 0.1%
12.99	1	< 0.1%

calculated_host_listings_count
Real number (ℝ)

Distinct	47
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.5838114

Minimum	1
Maximum	327
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	13
Maximum	327
Range	326
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	31.15475
Coefficient of variation (CV)	4.7320235
Kurtosis	77.214814
Mean	6.5838114
Median Absolute Deviation (MAD)	0
Skewness	8.4612229
Sum	125099
Variance	970.61846
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	12627	66.5%
2	2605	13.7%
3	1123	5.9%
4	539	2.8%
5	345	1.8%
6	208	1.1%
7	165	0.9%
8	164	0.9%
327	117	0.6%
9	98	0.5%
Other values (37)	1010	5.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	12627	66.5%
2	2605	13.7%
3	1123	5.9%
4	539	2.8%
5	345	1.8%
6	208	1.1%
7	165	0.9%
8	164	0.9%
9	98	0.5%
10	69	0.4%

Value	Count	Frequency (%)
327	117	0.6%
232	71	0.4%
121	44	0.2%
103	36	0.2%
96	69	0.4%
91	34	0.2%
87	32	0.2%
65	19	0.1%
52	41	0.2%
50	16	0.1%

availability_365
Real number (ℝ)

Distinct	366
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	109.72538

Minimum	0
Maximum	365
Zeros	6970
Zeros (%)	36.7%
Negative	0
Negative (%)	0.0%
Memory size	296.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	39
Q3	219
95-th percentile	358
Maximum	365
Range	365
Interquartile range (IQR)	219

Descriptive statistics

Standard deviation	130.5999
Coefficient of variation (CV)	1.1902433
Kurtosis	-0.93482914
Mean	109.72538
Median Absolute Deviation (MAD)	39
Skewness	0.80270185
Sum	2084892
Variance	17056.334
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6970	36.7%
365	432	2.3%
364	195	1.0%
1	176	0.9%
5	133	0.7%
3	115	0.6%
2	113	0.6%
179	112	0.6%
89	111	0.6%
6	110	0.6%
Other values (356)	10534	55.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6970	36.7%
1	176	0.9%
2	113	0.6%
3	115	0.6%
4	107	0.6%
5	133	0.7%
6	110	0.6%
7	96	0.5%
8	85	0.4%
9	83	0.4%

Value	Count	Frequency (%)
365	432	2.3%
364	195	1.0%
363	88	0.5%
362	62	0.3%
361	44	0.2%
360	33	0.2%
359	49	0.3%
358	53	0.3%
357	33	0.2%
356	26	0.1%

Auto

Heatmap
Table

	id	host_id	latitude	longitude	price	minimum_nights	number_of_reviews	reviews_per_month	calculated_host_listings_count	availability_365	neighbourhood_group	room_type
id	1.000	0.552	-0.008	0.080	-0.046	-0.073	-0.302	0.365	0.136	0.157	0.060	0.073
host_id	0.552	1.000	0.035	0.123	-0.102	-0.147	-0.114	0.271	0.142	0.164	0.102	0.099
latitude	-0.008	0.035	1.000	0.048	0.132	0.016	-0.032	-0.030	-0.002	-0.020	0.537	0.104
longitude	0.080	0.123	0.048	1.000	-0.418	-0.123	0.072	0.127	0.068	0.080	0.647	0.142
price	-0.046	-0.102	0.132	-0.418	1.000	0.106	-0.020	-0.020	-0.118	0.059	0.181	0.497
minimum_nights	-0.073	-0.147	0.016	-0.123	0.106	1.000	-0.164	-0.292	0.063	0.078	0.000	0.021
number_of_reviews	-0.302	-0.114	-0.032	0.072	-0.020	-0.164	1.000	0.707	0.066	0.257	0.026	0.000
reviews_per_month	0.365	0.271	-0.030	0.127	-0.020	-0.292	0.707	1.000	0.153	0.397	0.067	0.016
calculated_host_listings_count	0.136	0.142	-0.002	0.068	-0.118	0.063	0.066	0.153	1.000	0.411	0.085	0.094
availability_365	0.157	0.164	-0.020	0.080	0.059	0.078	0.257	0.397	0.411	1.000	0.079	0.093
neighbourhood_group	0.060	0.102	0.537	0.647	0.181	0.000	0.026	0.067	0.085	0.079	1.000	0.115
room_type	0.073	0.099	0.104	0.142	0.497	0.021	0.000	0.016	0.094	0.093	0.115	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
0	9138664	Private Lg Room 15 min to Manhattan	47594947	Iris	Queens	Sunnyside	40.74271	-73.92493	Private room	74	2	6	2019-05-26	0.13	1	5
1	31444015	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC	8523790	Johlex	Manhattan	Hell's Kitchen	40.76682	-73.98878	Entire home/apt	170	3	0	NaT	NaN	1	188
2	8741020	Voted #1 Location Quintessential 1BR W Village Apt	45854238	John	Manhattan	West Village	40.73631	-74.00611	Entire home/apt	245	3	51	2018-09-19	1.12	1	0
3	34602077	Spacious 1 bedroom apartment 15min from Manhattan	261055465	Regan	Queens	Astoria	40.76424	-73.92351	Entire home/apt	125	3	1	2019-05-24	0.65	1	13
4	23203149	Big beautiful bedroom in huge Bushwick apartment	143460	Megan	Brooklyn	Bushwick	40.69839	-73.92044	Private room	65	2	8	2019-06-23	0.52	2	8
5	4402805	LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK	22807362	Jenny	Brooklyn	Prospect-Lefferts Gardens	40.66025	-73.96270	Entire home/apt	120	3	3	2018-08-28	0.05	1	16
6	30070126	✩Prime Renovated 1/1 Apartment in Upper East Side✩	4968673	Sean	Manhattan	Upper East Side	40.76831	-73.95929	Entire home/apt	200	5	2	2019-05-26	0.68	1	71
7	34231172	Fully renovated brick house floor in Brooklyn	59642348	Kevin	Brooklyn	Sunset Park	40.64550	-74.01262	Entire home/apt	95	1	9	2019-07-08	9.00	1	106
8	5856760	Renovated 1BR in exciting, convenient area	29408349	Chad	Manhattan	Chinatown	40.71490	-73.99976	Entire home/apt	179	5	7	2017-04-18	0.14	1	0
9	7929441	Beautiful Loft w/ Waterfront View!	1453898	Anthony	Brooklyn	Williamsburg	40.71268	-73.96676	Private room	105	2	232	2019-06-19	5.00	3	64

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
19990	5192459	Quiet Room in 4BR UWS Brownstone	10677483	Greg	Manhattan	Upper West Side	40.80173	-73.96625	Private room	70	1	0	NaT	NaN	1	0
19991	1327940	Huge Gorgeous Park View Apartment!	3290436	Hadar	Brooklyn	Flatbush	40.65335	-73.96257	Entire home/apt	120	3	13	2016-08-27	0.28	2	327
19992	23612681	Shared Room 1 Stop from Manhattan on the F Train	55724558	Taylor	Queens	Long Island City	40.76006	-73.94080	Private room	55	4	2	2019-06-01	0.65	5	89
19993	34485745	Midtown Manhattan Stunner - Private room	261632622	Royalton	Manhattan	Theater District	40.75491	-73.98507	Private room	100	1	3	2019-06-16	3.00	9	318
19994	25616250	Stylish, spacious, private 1BR apt in Ditmas Park	125396920	Adam	Brooklyn	Flatbush	40.64314	-73.95705	Entire home/apt	75	3	10	2019-01-03	0.84	1	0
19995	7094539	Tranquil haven in bubbly Brooklyn	2052211	Adriana	Brooklyn	Windsor Terrace	40.65360	-73.97546	Entire home/apt	143	14	2	2016-08-27	0.04	1	10
19996	4424261	Large 1 BR with backyard on UWS	3447311	Sarah	Manhattan	Upper West Side	40.80188	-73.96808	Entire home/apt	200	2	22	2019-05-21	0.50	1	0
19997	4545882	Amazing studio/Loft with a backyard	23569951	Kaveh	Manhattan	Upper East Side	40.78110	-73.94567	Entire home/apt	220	3	28	2019-05-23	0.50	1	293
19998	26518547	U2 comfortable double bed sleeps 2 guests	295128	Carol Gloria	Bronx	Clason Point	40.81225	-73.85502	Private room	80	1	4	2019-07-01	1.48	7	365
19999	33631782	Private Bedroom in Williamsburg Apt!	8569221	Andi	Brooklyn	Williamsburg	40.71829	-73.95819	Private room	109	3	3	2019-04-28	1.07	2	97

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Lowercase Letter

Other Symbol

Uppercase Letter

Other Punctuation

Decimal Number

Math Symbol

Close Punctuation

Open Punctuation

Dash Punctuation

Space Separator

Final Punctuation

Nonspacing Mark

Initial Punctuation

Modifier Letter

Modifier Symbol

Control

Currency Symbol

Connector Punctuation

Other Number

Most occurring scripts

Most frequent character per script

Han

Common

Latin

Katakana

Cyrillic

Hebrew

Hangul

Hiragana

Inherited

Georgian

Devanagari

Most occurring blocks

Most frequent character per block

ASCII

Misc Symbols

Punctuation

VS

Dingbats

CJK

None

Georgian

Cyrillic

Hebrew

Hiragana

Geometric Shapes

Math Operators

Devanagari

Hangul

Letterlike Symbols

Misc Technical

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Letter

Other Punctuation

Decimal Number

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Math Symbol

Currency Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Han